﻿CREATE TABLE [dbo].[UDS_CM_ClientContact_Cooperatingman] (
    [ID]               int NOT NULL identity(1, 1),
    [ContactID]        int NULL,
    [CooperatingmanID] int NULL,

    CONSTRAINT [PK_UDS_CM_ClientContact_Cooperatingman] PRIMARY KEY CLUSTERED ([ID] asc),
    CONSTRAINT [FK_UDS_CM_ClientContact_Cooperatingman_UDS_CM_ClientContact] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[UDS_CM_ClientContact] ([ID]),
    CONSTRAINT [FK_UDS_CM_ClientContact_Cooperatingman_UDS_Staff] FOREIGN KEY ([CooperatingmanID]) REFERENCES [dbo].[UDS_Staff] ([Staff_ID]) ON UPDATE CASCADE
);
GO
